Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_54

R_54

ReferralSource

ReferralSourceText

ReferralSourceID

 

 

R_58

R_58

Language

ReferralSourceText

LanguageID

 

 

R_192

R_192

AdmissionMode

Episode

AdmissionModeID

 

 

R_193

R_193

DischargeDirection

Episode

DischargeDirectionID

 

 

R_194

R_194

AdmissionMode

AdmissionModeText

AdmissionModeID

 

 

R_195

R_195

DischargeDirection

DischargeDirectionText

DischargeDirectionID

 

 

R_196

R_196

Language

DischargeDirectionText

LanguageID

 

 

R_197

R_197

Language

AdmissionModeText

LanguageID

 

 

R_198

R_198

Hospital

Episode

HospitalID

 

 

R_199

R_199

Hospital

HospitalText

HospitalID

 

 

R_200

R_200

Language

HospitalText

LanguageID

 

 

R_201

R_201

EpisodeType

LEpisodeTypeOrgUnit

EpisodeTypeID

 

 

R_301

R_301

EpisodeType

AdmissionMode

EpisodeTypeID

 

 

R_302

R_302

EpisodeType

DischargeDirection

EpisodeTypeID

 

 

R_323

R_323

ReferralSource

Referral

ReferralSourceID

 

 

R_328

R_328

DischargeMode

Episode

DischargeModeID

 

 

R_329

R_329

DischargeMode

DischargeModeText

DischargeModeID

 

 

R_330

R_330

Language

DischargeModeText

LanguageID

 

 

R_428

R_428

Episode

LEpisodeAddress

EpisodeID

 

 

R_474

R_474

Address

LEpisodeAddress

AddressID

 

 

R_496

R_496

ReferralMode

ReferralModeText

ReferralModeID

 

 

R_497

R_497

ReferralMode

Referral

ReferralModeID

 

 

R_522

R_522

EpisodeType

DischargeMode

EpisodeTypeID

 

 

R_557

R_557

Referral

Episode

ReferralID

 

 

R_568

R_568

EpisodeStatus

EpisodeStatusText

EpisodeStatID

 

 

R_569

R_569

Language

EpisodeStatusText

LanguageID

 

 

R_570

R_570

EpisodeStatus

Episode

EpisodeStatID

 

 

R_581

R_581

EpisodeType

EpisodeTypeText

EpisodeTypeID

 

 

R_582

R_582

EpisodeType

Episode

EpisodeTypeID

 

 

R_583

R_583

Language

EpisodeTypeText

LanguageID

 

 

R_590

R_590

Episode

Event

EpisodeID

 

 

R_642

R_642

ExternalOrgUnit

Referral

ExternalOrgUnitID

 

 

R_643

R_643

ExternalDoctor

Referral

ExternalDoctorID

 

 

R_650

R_650

Category

CategoryText

CategoryID

 

 

R_651

R_651

Category

CategoryDictionary

CategoryID

 

 

R_653

R_653

CategoryDictionary

CategoryDictionaryText

CategoryDictionaryID

 

 

R_654

R_654

Category

LCategoryEpisode

CategoryID

 

 

R_655

R_655

Episode

LCategoryEpisode

EpisodeID

 

 

R_656

R_656

Referral

LCategoryReferral

ReferralID

 

 

R_661

R_661

Category

LCategoryReferral

CategoryID

 

 

R_662

R_662

CategoryDictionary

LCategoryReferral

CategoryDictionaryID

 

 

R_663

R_663

CategoryDictionary

LCategoryEpisode

CategoryDictionaryID

 

 

R_679

R_679

ExternalOrgUnit

LEpisodeGP

ExternalOrgUnitID

 

 

R_680

R_680

ExternalDoctor

LEpisodeGP

ExternalDoctorID

 

 

R_681

R_681

Episode

LEpisodeGP

EpisodeID

 

 

R_1479

R_1479

EpisodeKind

Episode

EpisodeKindID

 

 

R_1481

R_1481

EpisodeKind

EpisodeKindText

EpisodeKindID

 

 

R_1610

R_1610

PreviousTreatmentPlace

PreviousTreatmentPlaceText

PreviousTreatmentPlaceID

 

 

R_1611

R_1611

PreviousTreatmentPlace

Referral

PreviousTreatmentPlaceID

 

 

R_1870

R_1870

HospitalizationMode

HospitalizationModeText

HospitalizationModeID

 

 


2